﻿-- Ajout de la colonne IsSubEntity à la table medianamik_Node
	
IF NOT EXISTS(
Select * FROM Information_Schema.COLUMNS
where TABLE_SCHEMA = 'dbo'
AND TABLE_NAME = 'medianamik_Node'
AND Column_Name = 'IsSubEntity'
)
BEGIN
	ALTER TABLE dbo.medianamik_Node ADD
	IsSubEntity bit NOT NULL CONSTRAINT DF_medianamik_Node_IsSubEntity DEFAULT 0
END